|
KMID : 1812620210010020179
|
|
HIRA Research
2021 Volume.1 No. 2 p.179 ~ p.195
|
|
|
Experience of Converting Clinical Data Warehouse to Common Data Model and Additional Data Loading
|
|
Ko Soo-Jeong
Park Sang-Jun
Chang Dong-Jin
|
|
|
Abstract
|
|
|
Background: Clinical Data Warehouse (CDW) enables healthcare organizations to allow investigators to utilize their anonymous data securely. The Common Data Model (CDM) enables collaborative research between institutions. The authors describe the experience of converting CDW data into the Observational Medical Outcomes Partnership (OMOP) CDM (OMOP-CDM).
Methods: Data from electronic health records of a medical center was converted into OMOP-CDM ver. 5.3.1 (https://www.ohdsi.org/data-standardization/the-common-data-model/). Source codes of the institution were mapped to the codes in the standard vocabularies. Predefined data were extracted, transformed, and loaded into the CDM tables. Ophthalmologic data were digitalized and structured per their data configuration.
Results: The number of total patients with available data in the CDW was 8,532,392. The data from 878,141 patients were converted into CDM structure after the codes were mapped to those in the standard vocabularies. Visual acuity, intraocular pressure, automated visual field test, and optical coherence tomography were digitalized and stored.
Conclusion: Although it requires plenty of resources to convert the data set to CDM, it is worthy of keeping the activity since it provides opportunities for investigators to participate in various studies.
|
|
|
KEYWORD
|
|
|
Common Data Model, Clinical Data Warehouse, Observational Medical Outcomes Partnership
|
|
|
FullTexts / Linksout information
|
|
|
|
|
Listed journal information
|
|
|
|